package guoanmaker.provider.business.repository;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import guoanmaker.provider.business.model.ProvideCommodityServiceRange;

public interface ProvideCommodityServiceRangeRepository extends JpaRepository<ProvideCommodityServiceRange, String>,JpaSpecificationExecutor<ProvideCommodityServiceRange>{
	@Query("select s from ProvideCommodityServiceRange s left join  s.commodity c where  c.id=s.commodity.id  and  c.id=:id")
	public  List<ProvideCommodityServiceRange>    selectByServerArea(@Param("id") String id);
}
